EXCEL: Macros to add borders and Fix dates

\ by 

Sub ColumnToDateTime()
'
' ColumnToDateTime Macro
'

'
ActiveCell.Columns("A:A").EntireColumn.Select
Selection.NumberFormat = "yyyy-mm-dd hh:mm:ss"
End Sub



Sub AddBorders()
'
' AddBorders Macro
'

'
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
With Selection.Borders(xlEdgeLeft)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeTop)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlEdgeRight)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideVertical)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
With Selection.Borders(xlInsideHorizontal)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
End With
End Sub

Add buttons.

Posted in: Excel

htaccess upload max filesize

\ by 


# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /localwp/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /localwp/index.php [L]
php_value upload_max_filesize 64M
php_value post_max_size 64M
php_value max_execution_time 300
php_value max_input_time 300
</IfModule>

# END WordPress
Posted in: Wordpress

Outlook 2010 QAT file not found error – unable to change QAT

\ by

 … cannot change my Outlook 2010 Quick Access Toolbar.  When I try to do so, I get an error message “the file does not exist.”  A web search indicated that the fix is to delete the access.officeUI file to force Outlook to create a new one.  However, I do not find any such file … It turns out that this was due to a missing sound file, if you can believe it. I was able to fix this by unchecking the “Play reminder sound:” in the Advanced section under Outlook Files/Options.

  • Outlook / File / Options / Advanced /
  • uncheck Play reminder sound
  • On QAT, right click and Customize Quick Access Toolbar
    • Choose Macros from Choose commands
      • Add
      • Press OK which should now save correctly.

As it turns out the file combo box was empty. This happened during upgrade from Windows 7 to Windows 10 as the Office14 folder moved to Program Files/Office14.

Posted in: Debugging, HowTo, PC, Settings, Windows

MP4 to DVD or ISO converter

\ by

Now that you have a good MP4 you might want to make it into a DVD.

Try this site and use DVD Flick.

  • Add a “title” or MP4 file
  • Change the Project destination folder at the bottom of the screen to write the DVD folders to.

  • Click Create DVD

  • Then either play from the folders (creates one called dvd) or use ImgBurn to create iso or dvd disk.

That’s it!

Posted in: Video \ Tagged:

How to rip a DVD with CSS and other protection

\ by

Ever rented a DVD which no longer plays on your DVD player or changer? A bit annoying. Take a backup!

  • Download the free version of WonderFox DVD Ripper Speedy.
  • Choose the main movie. (In my case I had to choose a couple of tracks as there were two “movies” or episodes.
  • The only setting I changed was we like to see subtitles

Since WonderFox only saved as MPG we need it to be in an MP4 container to play with our Plex server.

  • Import the movie into MovieMaker. I still had my copy from when I upgraded Windows from 7 to 10.

  • I’m just saving using the recommended setting with the Save Movie icon on the right.

 That’s it!

Posted in: Music, Video \ Tagged:

Windows 10 changes – “previous versions” are now File History

\ by

Surprise?! After Windows 7 System Restore no longer keeps backup copies of previous versions of your files. File History isn’t enabled by default, so you can’t restore previous versions of files unless make some changes.

Go to File History and add an external drive.

File History only backs up copies of files that are in the Documents, Music, Pictures, Videos, and Desktop folders and the OneDrive files available offline on your PC. If you have files or folders elsewhere that you want backed up, you can add them to one of these folders.

Surprise #2. It will start backing up every file on your system without asking!

The reason I thought about using this feature is when my old Vista was hacked by ransomware, after I got control of the PC again, I was able to recovery all files (back to the previous version.)

External: Other choices of backing up your data.

Settings:

Make changes here as needed.

 

 

 

Posted in: Windows \ Tagged:

How to save a Facebook Video to your PC local disk

\ by
  1. Right click on a video. Choose
    1. Show video URL
  2. Copy and paste into a new tab. (I use Chrome)
  3. Replace the www in the URL with https://m.facebook.com/user_name/video/asodufyduafetc/
  4. Now you are on the FB mobile site. Don’t worry if the video looks small. It doesn’t matter.
  5. Click to start the video.
  6. Pause, right click on the screen and select “Save video as” to save to your local disk.

 

Posted in: Video \ Tagged: